-- ----------------------------
--  Table structure for `tb_bird`
-- ----------------------------
DROP TABLE IF EXISTS `tb_bird`;
CREATE TABLE `tb_bird` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `age` int(11) DEFAULT '0' COMMENT '年龄',
  `name` varchar(200) DEFAULT NULL COMMENT '名字',
  `description` varchar(500) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tb_bird`
-- ----------------------------
BEGIN;
INSERT INTO `tb_bird` VALUES ('1', '18', 'a', 'n'), ('2', '18', 'b', 'n'), ('3', '18', 'b', 'n'), ('4', '19', 'a', 'n'), ('5', '19', 'e', 'n');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;



DROP TABLE IF EXISTS `animal`;
CREATE TABLE `animal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(500) NOT NULL,
  `animalInfoId` int(11) NOT NULL DEFAULT '1' COMMENT '动物信息id',
  `age` int(11) DEFAULT '5' COMMENT '动物年龄',
  `description` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `animal`
-- ----------------------------
BEGIN;
INSERT INTO `animal` VALUES ('1', '鸭子', '1', '5',''), ('2', '小鸡', '1', '6',''), ('3', '啄木鸟', '1', '6',''), ('4', '海豚', '2', '9','朱洛毅在哪儿呢!'), ('5', '虎鲸', '2', '15','呆毛在哪儿呢!'), ('6', '鲨鱼', '2', '15','本拉登在哪儿呢!'), ('7', '蝴蝶', '3', '1',''), ('8', '蜜蜂', '3', '2',''), ('9', '蜻蜓', '3', '3','');
COMMIT;




DROP TABLE IF EXISTS `animal_info`;
CREATE TABLE `animal_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `outline` varchar(500) NOT NULL COMMENT '纲',
  `regionName` varchar(500) DEFAULT NULL COMMENT '分布区域',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `animal _info`
-- ----------------------------
BEGIN;
INSERT INTO `animal_info` VALUES ('1', '鸟纲', '全球'), ('2', '哺乳纲', '世界各大洋及河流中都有分布'), ('3', '昆虫纲', '全球');
COMMIT;
